Step 1: Choose a line and clustered column chart
a. Shared axis = Offense_Code_Group, Offense_Description, Day of Week, Time by Hour ; Column Values = Violent Crimes average per day (change name to Violent Crime Per Day) ; Line Values = Violent Crimes YOY% (remove period)
b. Select formatting, in general X position = 155, Y position = 79, Width 586, Height = 306
c. Legend, color = black, font = Constantia, text size = 10
d. X axis, color = black, text size = 10, font = Constantia, title off
e. Y axis, start = .5, color = black, text size = 10, font = Constantia
f. Data Colors, Violent Crimes YOY% = custom (FCB714), Default color = custom (1E5A8E)
g. Data labels, color = black, text size = 9, font = Constantia , show background off, customize series on, Violent Crime Per Day show off
h. Shapes, shade area on
i. Title, Violent Crime per Day by Group, color = black, background = light gray, alignment = center, text size = 12, font = Constantia
j. Border, dark gray
k. Sort the chart by Violent Crimes per Day and format Violent Crimes YOY to a percentage
Here is an article on Crime per Day in Boston